/*
 Navicat Premium Data Transfer

 Source Server         : 39.106.214.19
 Source Server Type    : Oracle
 Source Server Version : 120100
 Source Host           : 39.106.214.19:1521
 Source Schema         : WSL

 Target Server Type    : Oracle
 Target Server Version : 120100
 File Encoding         : 65001

 Date: 07/07/2020 14:10:21
*/


-- ----------------------------
-- Table structure for CBT_COMP_INFO
-- ----------------------------

CREATE TABLE "CBT_COMP_INFO" (
  "COMP_ID" NUMBER VISIBLE NOT NULL,
  "COMP_NAME" VARCHAR2(100 BYTE) VISIBLE NOT NULL,
  "START_TIME" DATE VISIBLE,
  "END_TIME" DATE VISIBLE,
  "PF" NUMBER VISIBLE,
  "CL" NUMBER VISIBLE,
  "TA" NUMBER VISIBLE,
  "PA" NUMBER VISIBLE,
  "CE" NUMBER VISIBLE,
  "RE" NUMBER VISIBLE,
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE,
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE,
  "UPDATE_TIME" DATE VISIBLE,
  "MEM_NUM" NUMBER VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "CBT_COMP_INFO"."COMP_ID" IS '竞赛ID';
COMMENT ON COLUMN "CBT_COMP_INFO"."COMP_NAME" IS '竞赛名称';
COMMENT ON COLUMN "CBT_COMP_INFO"."START_TIME" IS '开始时间';
COMMENT ON COLUMN "CBT_COMP_INFO"."END_TIME" IS '截止时间';
COMMENT ON COLUMN "CBT_COMP_INFO"."PF" IS '专业领域';
COMMENT ON COLUMN "CBT_COMP_INFO"."CL" IS '竞赛评级';
COMMENT ON COLUMN "CBT_COMP_INFO"."TA" IS '理论能力';
COMMENT ON COLUMN "CBT_COMP_INFO"."PA" IS '运用能力';
COMMENT ON COLUMN "CBT_COMP_INFO"."CE" IS '竞赛经验';
COMMENT ON COLUMN "CBT_COMP_INFO"."RE" IS '疲劳值';
COMMENT ON COLUMN "CBT_COMP_INFO"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "CBT_COMP_INFO"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "CBT_COMP_INFO"."UPDATE_BY" IS '修改者';
COMMENT ON COLUMN "CBT_COMP_INFO"."UPDATE_TIME" IS '修改时间';
COMMENT ON COLUMN "CBT_COMP_INFO"."MEM_NUM" IS '匹配成员数';
COMMENT ON TABLE "CBT_COMP_INFO" IS '竞赛属性表';

-- ----------------------------
-- Records of CBT_COMP_INFO
-- ----------------------------

-- ----------------------------
-- Table structure for CBT_COMP_TEAM
-- ----------------------------

CREATE TABLE "CBT_COMP_TEAM" (
  "TEAM_ID" NUMBER VISIBLE NOT NULL,
  "COMP_ID" NUMBER VISIBLE NOT NULL,
  "STATUS" NUMBER VISIBLE DEFAULT -1   NOT NULL,
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE,
  "CREATE_TIME" DATE VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "CBT_COMP_TEAM"."TEAM_ID" IS '团队ID';
COMMENT ON COLUMN "CBT_COMP_TEAM"."COMP_ID" IS '竞赛ID';
COMMENT ON COLUMN "CBT_COMP_TEAM"."STATUS" IS '团队状态';
COMMENT ON COLUMN "CBT_COMP_TEAM"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "CBT_COMP_TEAM"."CREATE_TIME" IS '创建时间';
COMMENT ON TABLE "CBT_COMP_TEAM" IS '竞赛团队表';

-- ----------------------------
-- Records of CBT_COMP_TEAM
-- ----------------------------

-- ----------------------------
-- Table structure for CBT_TEAM_USER
-- ----------------------------

CREATE TABLE "CBT_TEAM_USER" (
  "TEAM_ID" NUMBER VISIBLE NOT NULL,
  "USER_ID" NUMBER VISIBLE NOT NULL,
  "ELA" NUMBER VISIBLE,
  "ECA" NUMBER VISIBLE,
  "TU_ID" NUMBER VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "CBT_TEAM_USER"."TEAM_ID" IS '团队ID';
COMMENT ON COLUMN "CBT_TEAM_USER"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "CBT_TEAM_USER"."ELA" IS '领导能力评价';
COMMENT ON COLUMN "CBT_TEAM_USER"."ECA" IS '协作能力评价';
COMMENT ON COLUMN "CBT_TEAM_USER"."TU_ID" IS '组队序号';
COMMENT ON TABLE "CBT_TEAM_USER" IS '团队成员表';

-- ----------------------------
-- Records of CBT_TEAM_USER
-- ----------------------------


-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------

CREATE TABLE "QRTZ_BLOB_TRIGGERS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "TRIGGER_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "TRIGGER_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "BLOB_DATA" BLOB VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_BLOB_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------

CREATE TABLE "QRTZ_CALENDARS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "CALENDAR_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "CALENDAR" BLOB VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_CALENDARS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------

CREATE TABLE "QRTZ_CRON_TRIGGERS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "TRIGGER_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "TRIGGER_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "CRON_EXPRESSION" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "TIME_ZONE_ID" VARCHAR2(80 BYTE) VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
INSERT INTO "QRTZ_CRON_TRIGGERS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', '0/20 * * * * ?', 'Asia/Shanghai');
INSERT INTO "QRTZ_CRON_TRIGGERS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai');
INSERT INTO "QRTZ_CRON_TRIGGERS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai');

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------

CREATE TABLE "QRTZ_FIRED_TRIGGERS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "ENTRY_ID" VARCHAR2(95 BYTE) VISIBLE NOT NULL,
  "TRIGGER_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "TRIGGER_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "INSTANCE_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "FIRED_TIME" NUMBER(13,0) VISIBLE NOT NULL,
  "SCHED_TIME" NUMBER(13,0) VISIBLE NOT NULL,
  "PRIORITY" NUMBER(13,0) VISIBLE NOT NULL,
  "STATE" VARCHAR2(16 BYTE) VISIBLE NOT NULL,
  "JOB_NAME" VARCHAR2(200 BYTE) VISIBLE,
  "JOB_GROUP" VARCHAR2(200 BYTE) VISIBLE,
  "IS_NONCONCURRENT" VARCHAR2(1 BYTE) VISIBLE,
  "REQUESTS_RECOVERY" VARCHAR2(1 BYTE) VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_FIRED_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------

CREATE TABLE "QRTZ_JOB_DETAILS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "JOB_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "JOB_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "DESCRIPTION" VARCHAR2(250 BYTE) VISIBLE,
  "JOB_CLASS_NAME" VARCHAR2(250 BYTE) VISIBLE NOT NULL,
  "IS_DURABLE" VARCHAR2(1 BYTE) VISIBLE NOT NULL,
  "IS_NONCONCURRENT" VARCHAR2(1 BYTE) VISIBLE NOT NULL,
  "IS_UPDATE_DATA" VARCHAR2(1 BYTE) VISIBLE NOT NULL,
  "REQUESTS_RECOVERY" VARCHAR2(1 BYTE) VISIBLE NOT NULL,
  "JOB_DATA" BLOB VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
INSERT INTO "QRTZ_JOB_DETAILS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', HEXTORAW('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001622CDE29E07870707070707400013174000E302F3230202A202A202A202A203F74003872795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C203130302974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000003740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC8974000133740001317800'));
INSERT INTO "QRTZ_JOB_DETAILS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', HEXTORAW('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001622CDE29E07870707070707400013174000E302F3130202A202A202A202A203F74001172795461736B2E72794E6F506172616D7374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC8974000133740001317800'));
INSERT INTO "QRTZ_JOB_DETAILS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, 'com.ruoyi.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', HEXTORAW('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001E636F6D2E72756F79692E71756172747A2E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E000978720027636F6D2E72756F79692E636F6D6D6F6E2E636F72652E646F6D61696E2E42617365456E7469747900000000000000010200074C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0006706172616D7371007E00034C000672656D61726B71007E00094C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000C787074000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001622CDE29E07870707070707400013174000E302F3135202A202A202A202A203F74001572795461736B2E7279506172616D7328277279272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC8974000133740001317800'));

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------

CREATE TABLE "QRTZ_LOCKS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "LOCK_NAME" VARCHAR2(40 BYTE) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
INSERT INTO "QRTZ_LOCKS" VALUES ('RuoyiScheduler', 'STATE_ACCESS');
INSERT INTO "QRTZ_LOCKS" VALUES ('RuoyiScheduler', 'TRIGGER_ACCESS');

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------

CREATE TABLE "QRTZ_PAUSED_TRIGGER_GRPS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "TRIGGER_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------

CREATE TABLE "QRTZ_SCHEDULER_STATE" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "INSTANCE_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "LAST_CHECKIN_TIME" NUMBER(13,0) VISIBLE NOT NULL,
  "CHECKIN_INTERVAL" NUMBER(13,0) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
INSERT INTO "QRTZ_SCHEDULER_STATE" VALUES ('RuoyiScheduler', 'DESKTOP-CHPOAID1594101667943', '1594102128657', '15000');

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------

CREATE TABLE "QRTZ_SIMPLE_TRIGGERS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "TRIGGER_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "TRIGGER_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "REPEAT_COUNT" NUMBER(7,0) VISIBLE NOT NULL,
  "REPEAT_INTERVAL" NUMBER(12,0) VISIBLE NOT NULL,
  "TIMES_TRIGGERED" NUMBER(10,0) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_SIMPLE_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------

CREATE TABLE "QRTZ_SIMPROP_TRIGGERS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "TRIGGER_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "TRIGGER_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "STR_PROP_1" VARCHAR2(512 BYTE) VISIBLE,
  "STR_PROP_2" VARCHAR2(512 BYTE) VISIBLE,
  "STR_PROP_3" VARCHAR2(512 BYTE) VISIBLE,
  "INT_PROP_1" NUMBER(10,0) VISIBLE,
  "INT_PROP_2" NUMBER(10,0) VISIBLE,
  "LONG_PROP_1" NUMBER(13,0) VISIBLE,
  "LONG_PROP_2" NUMBER(13,0) VISIBLE,
  "DEC_PROP_1" NUMBER(13,4) VISIBLE,
  "DEC_PROP_2" NUMBER(13,4) VISIBLE,
  "BOOL_PROP_1" VARCHAR2(1 BYTE) VISIBLE,
  "BOOL_PROP_2" VARCHAR2(1 BYTE) VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_SIMPROP_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------

CREATE TABLE "QRTZ_TRIGGERS" (
  "SCHED_NAME" VARCHAR2(120 BYTE) VISIBLE NOT NULL,
  "TRIGGER_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "TRIGGER_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "JOB_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "JOB_GROUP" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "DESCRIPTION" VARCHAR2(250 BYTE) VISIBLE,
  "NEXT_FIRE_TIME" NUMBER(13,0) VISIBLE,
  "PREV_FIRE_TIME" NUMBER(13,0) VISIBLE,
  "PRIORITY" NUMBER(13,0) VISIBLE,
  "TRIGGER_STATE" VARCHAR2(16 BYTE) VISIBLE NOT NULL,
  "TRIGGER_TYPE" VARCHAR2(8 BYTE) VISIBLE NOT NULL,
  "START_TIME" NUMBER(13,0) VISIBLE NOT NULL,
  "END_TIME" NUMBER(13,0) VISIBLE,
  "CALENDAR_NAME" VARCHAR2(200 BYTE) VISIBLE,
  "MISFIRE_INSTR" NUMBER(2,0) VISIBLE,
  "JOB_DATA" BLOB VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
INSERT INTO "QRTZ_TRIGGERS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, '1594101675000', '-1', '5', 'PAUSED', 'CRON', '1594101670000', '0', NULL, '2', NULL);
INSERT INTO "QRTZ_TRIGGERS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, '1594101680000', '-1', '5', 'PAUSED', 'CRON', '1594101671000', '0', NULL, '2', NULL);
INSERT INTO "QRTZ_TRIGGERS" VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, '1594101670000', '-1', '5', 'PAUSED', 'CRON', '1594101668000', '0', NULL, '2', NULL);

-- ----------------------------
-- Table structure for SYS_CONFIG
-- ----------------------------

CREATE TABLE "SYS_CONFIG" (
  "CONFIG_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "CONFIG_NAME" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "CONFIG_KEY" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "CONFIG_VALUE" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "CONFIG_TYPE" CHAR(1 BYTE) VISIBLE DEFAULT 'N',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE DEFAULT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_ID" IS '参数主键seq_sys_config.nextval';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_NAME" IS '参数名称';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_KEY" IS '参数键名';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_VALUE" IS '参数键值';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_TYPE" IS '系统内置（Y是 N否）';
COMMENT ON COLUMN "SYS_CONFIG"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_CONFIG"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_CONFIG"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_CONFIG"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_CONFIG"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_CONFIG" IS '参数配置表';

-- ----------------------------
-- Records of SYS_CONFIG
-- ----------------------------
INSERT INTO "SYS_CONFIG" VALUES ('1', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO "SYS_CONFIG" VALUES ('2', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '初始化密码 123456');
INSERT INTO "SYS_CONFIG" VALUES ('3', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '深黑主题theme-dark，浅色主题theme-light，深蓝主题theme-blue');
INSERT INTO "SYS_CONFIG" VALUES ('4', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-07 06:07:41', 'SYYYY-MM-DD HH24:MI:SS'), '是否开启注册用户功能');

-- ----------------------------
-- Table structure for SYS_DEPT
-- ----------------------------

CREATE TABLE "SYS_DEPT" (
  "DEPT_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "PARENT_ID" NUMBER(20,0) VISIBLE DEFAULT 0,
  "ANCESTORS" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "DEPT_NAME" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "ORDER_NUM" NUMBER(4,0) VISIBLE DEFAULT 0,
  "LEADER" VARCHAR2(20 BYTE) VISIBLE DEFAULT NULL,
  "PHONE" VARCHAR2(11 BYTE) VISIBLE DEFAULT NULL,
  "EMAIL" VARCHAR2(50 BYTE) VISIBLE DEFAULT NULL,
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "DEL_FLAG" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_DEPT"."DEPT_ID" IS '部门主键seq_sys_dept.nextval';
COMMENT ON COLUMN "SYS_DEPT"."PARENT_ID" IS '父部门id';
COMMENT ON COLUMN "SYS_DEPT"."ANCESTORS" IS '祖级列表';
COMMENT ON COLUMN "SYS_DEPT"."DEPT_NAME" IS '部门名称';
COMMENT ON COLUMN "SYS_DEPT"."ORDER_NUM" IS '显示顺序';
COMMENT ON COLUMN "SYS_DEPT"."LEADER" IS '负责人';
COMMENT ON COLUMN "SYS_DEPT"."PHONE" IS '联系电话';
COMMENT ON COLUMN "SYS_DEPT"."EMAIL" IS '邮箱';
COMMENT ON COLUMN "SYS_DEPT"."STATUS" IS '部门状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_DEPT"."DEL_FLAG" IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN "SYS_DEPT"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_DEPT"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_DEPT"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_DEPT"."UPDATE_TIME" IS '更新时间';
COMMENT ON TABLE "SYS_DEPT" IS '部门信息表';

-- ----------------------------
-- Records of SYS_DEPT
-- ----------------------------
INSERT INTO "SYS_DEPT" VALUES ('205', '202', '0,100,200,202', '信息管理与信息系统', '3', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-04-21 02:50:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('206', '202', '0,100,200,202', '通信工程', '4', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-04-21 02:51:08', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('202', '200', '0,100,200', '2013级', '1', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-04-21 02:49:46', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('203', '202', '0,100,200,202', '计算机科学与技术', '1', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-04-21 02:50:09', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('204', '202', '0,100,200,202', '计算机科学与技术（软件方向）', '2', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-04-21 02:50:35', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('225', '221', '0,100,200,221', '通信工程', '4', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-06-16 09:50:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('223', '221', '0,100,200,221', '软件工程', '2', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-06-16 09:50:27', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('224', '221', '0,100,200,221', '信息管理与信息系统', '3', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-06-16 09:50:43', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('100', '0', '0', '辽宁大学', '0', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-04-15 10:28:03', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_DEPT" VALUES ('200', '100', '0,100', '信息学院', '1', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_DEPT" VALUES ('201', '100', '0,100', '物理学院', '2', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_DEPT" VALUES ('103', '100', '0,100', 'admin', '100', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-04-15 10:28:03', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_DEPT" VALUES ('221', '200', '0,100,200', '2014级', '2', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-06-16 09:49:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('222', '221', '0,100,200,221', '计算机科学与技术', '1', NULL, NULL, NULL, '0', '0', 'admin', TO_DATE('2020-06-16 09:49:58', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);

-- ----------------------------
-- Table structure for SYS_DICT_DATA
-- ----------------------------

CREATE TABLE "SYS_DICT_DATA" (
  "DICT_CODE" NUMBER(20,0) VISIBLE NOT NULL,
  "DICT_SORT" NUMBER(4,0) VISIBLE DEFAULT 0,
  "DICT_LABEL" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "DICT_VALUE" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "DICT_TYPE" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "CSS_CLASS" VARCHAR2(100 BYTE) VISIBLE DEFAULT NULL,
  "LIST_CLASS" VARCHAR2(100 BYTE) VISIBLE DEFAULT NULL,
  "IS_DEFAULT" CHAR(1 BYTE) VISIBLE DEFAULT 'N',
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE DEFAULT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_CODE" IS '字典主键seq_sys_dict_data.nextval';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_SORT" IS '字典排序';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_LABEL" IS '字典标签';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_VALUE" IS '字典键值';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_TYPE" IS '字典类型';
COMMENT ON COLUMN "SYS_DICT_DATA"."CSS_CLASS" IS '样式属性（其他样式扩展）';
COMMENT ON COLUMN "SYS_DICT_DATA"."LIST_CLASS" IS '表格回显样式';
COMMENT ON COLUMN "SYS_DICT_DATA"."IS_DEFAULT" IS '是否默认（Y是 N否）';
COMMENT ON COLUMN "SYS_DICT_DATA"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_DICT_DATA"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_DICT_DATA"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_DICT_DATA"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_DICT_DATA"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_DICT_DATA"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_DICT_DATA" IS '字典数据表';

-- ----------------------------
-- Records of SYS_DICT_DATA
-- ----------------------------
INSERT INTO "SYS_DICT_DATA" VALUES ('122', '3', '组队失败', '3', 'comp_team_status', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2020-06-16 03:41:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('140', '4', '智能匹配', '1', 'comp_team_status', NULL, 'warning', 'Y', '0', 'admin', TO_DATE('2020-06-25 04:59:01', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-06 01:43:24', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('1', '1', '男', '0', 'sys_user_sex', NULL, NULL, 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '性别男');
INSERT INTO "SYS_DICT_DATA" VALUES ('2', '2', '女', '1', 'sys_user_sex', NULL, NULL, 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '性别女');
INSERT INTO "SYS_DICT_DATA" VALUES ('120', '1', '组队中', '0', 'comp_team_status', NULL, 'primary', 'N', '0', 'admin', TO_DATE('2020-06-16 03:30:14', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-06-16 03:39:56', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('4', '1', '显示', '0', 'sys_show_hide', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '显示菜单');
INSERT INTO "SYS_DICT_DATA" VALUES ('5', '2', '隐藏', '1', 'sys_show_hide', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '隐藏菜单');
INSERT INTO "SYS_DICT_DATA" VALUES ('6', '1', '正常', '0', 'sys_normal_disable', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('7', '2', '停用', '1', 'sys_normal_disable', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '停用状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('8', '1', '正常', '0', 'sys_job_status', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('9', '2', '暂停', '1', 'sys_job_status', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '停用状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('10', '1', '默认', 'DEFAULT', 'sys_job_group', NULL, NULL, 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '默认分组');
INSERT INTO "SYS_DICT_DATA" VALUES ('11', '2', '系统', 'SYSTEM', 'sys_job_group', NULL, NULL, 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '系统分组');
INSERT INTO "SYS_DICT_DATA" VALUES ('12', '1', '是', 'Y', 'sys_yes_no', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '系统默认是');
INSERT INTO "SYS_DICT_DATA" VALUES ('13', '2', '否', 'N', 'sys_yes_no', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '系统默认否');
INSERT INTO "SYS_DICT_DATA" VALUES ('14', '1', '通知', '1', 'sys_notice_type', NULL, 'warning', 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '通知');
INSERT INTO "SYS_DICT_DATA" VALUES ('15', '2', '公告', '2', 'sys_notice_type', NULL, 'success', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '公告');
INSERT INTO "SYS_DICT_DATA" VALUES ('16', '1', '正常', '0', 'sys_notice_status', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('17', '2', '关闭', '1', 'sys_notice_status', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '关闭状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('18', '99', '其他', '0', 'sys_oper_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '其他操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('19', '1', '新增', '1', 'sys_oper_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '新增操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('20', '2', '修改', '2', 'sys_oper_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '修改操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('21', '3', '删除', '3', 'sys_oper_type', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '删除操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('22', '4', '授权', '4', 'sys_oper_type', NULL, 'primary', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '授权操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('23', '5', '导出', '5', 'sys_oper_type', NULL, 'warning', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '导出操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('24', '6', '导入', '6', 'sys_oper_type', NULL, 'warning', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '导入操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('25', '7', '强退', '7', 'sys_oper_type', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '强退操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('26', '8', '生成代码', '8', 'sys_oper_type', NULL, 'warning', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '生成操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('27', '9', '清空数据', '9', 'sys_oper_type', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '清空操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('28', '1', '成功', '0', 'sys_common_status', NULL, 'primary', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('29', '2', '失败', '1', 'sys_common_status', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '停用状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('121', '2', '组队成功', '2', 'comp_team_status', NULL, 'success', 'N', '0', 'admin', TO_DATE('2020-06-16 03:40:34', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);

-- ----------------------------
-- Table structure for SYS_DICT_TYPE
-- ----------------------------

CREATE TABLE "SYS_DICT_TYPE" (
  "DICT_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "DICT_NAME" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "DICT_TYPE" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE DEFAULT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_DICT_TYPE"."DICT_ID" IS '字典主键seq_sys_dict_type.nextval';
COMMENT ON COLUMN "SYS_DICT_TYPE"."DICT_NAME" IS '字典名称';
COMMENT ON COLUMN "SYS_DICT_TYPE"."DICT_TYPE" IS '字典类型';
COMMENT ON COLUMN "SYS_DICT_TYPE"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_DICT_TYPE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_DICT_TYPE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_DICT_TYPE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_DICT_TYPE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_DICT_TYPE"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_DICT_TYPE" IS '字典类型表';

-- ----------------------------
-- Records of SYS_DICT_TYPE
-- ----------------------------
INSERT INTO "SYS_DICT_TYPE" VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '用户性别列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '菜单状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '系统开关列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '任务状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '任务分组列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '系统是否列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '通知类型列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '通知状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '操作类型列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '登录状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('120', '团队状态', 'comp_team_status', '0', 'admin', TO_DATE('2020-06-16 03:28:55', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-06-16 03:41:51', 'SYYYY-MM-DD HH24:MI:SS'), '团队当前状态');

-- ----------------------------
-- Table structure for SYS_JOB
-- ----------------------------

CREATE TABLE "SYS_JOB" (
  "JOB_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "JOB_NAME" VARCHAR2(64 BYTE) VISIBLE DEFAULT '' NOT NULL,
  "JOB_GROUP" VARCHAR2(64 BYTE) VISIBLE DEFAULT '' NOT NULL,
  "INVOKE_TARGET" VARCHAR2(500 BYTE) VISIBLE NOT NULL,
  "CRON_EXPRESSION" VARCHAR2(255 BYTE) VISIBLE DEFAULT '',
  "MISFIRE_POLICY" VARCHAR2(20 BYTE) VISIBLE DEFAULT '3',
  "CONCURRENT" CHAR(1 BYTE) VISIBLE DEFAULT '1',
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE DEFAULT ''
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_JOB"."JOB_ID" IS '任务主键seq_sys_job.nextval';
COMMENT ON COLUMN "SYS_JOB"."JOB_NAME" IS '任务名称';
COMMENT ON COLUMN "SYS_JOB"."JOB_GROUP" IS '任务组名';
COMMENT ON COLUMN "SYS_JOB"."INVOKE_TARGET" IS '调用目标字符串';
COMMENT ON COLUMN "SYS_JOB"."CRON_EXPRESSION" IS 'cron执行表达式';
COMMENT ON COLUMN "SYS_JOB"."MISFIRE_POLICY" IS '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';
COMMENT ON COLUMN "SYS_JOB"."CONCURRENT" IS '是否并发执行（0允许 1禁止）';
COMMENT ON COLUMN "SYS_JOB"."STATUS" IS '状态（0正常 1暂停）';
COMMENT ON COLUMN "SYS_JOB"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_JOB"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_JOB"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_JOB"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_JOB"."REMARK" IS '备注信息';
COMMENT ON TABLE "SYS_JOB" IS '定时任务调度表';

-- ----------------------------
-- Records of SYS_JOB
-- ----------------------------
INSERT INTO "SYS_JOB" VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_JOB" VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(''ry'')', '0/15 * * * * ?', '3', '1', '1', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_JOB" VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);

-- ----------------------------
-- Table structure for SYS_JOB_LOG
-- ----------------------------

CREATE TABLE "SYS_JOB_LOG" (
  "JOB_LOG_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "JOB_NAME" VARCHAR2(64 BYTE) VISIBLE NOT NULL,
  "JOB_GROUP" VARCHAR2(64 BYTE) VISIBLE NOT NULL,
  "INVOKE_TARGET" VARCHAR2(500 BYTE) VISIBLE NOT NULL,
  "JOB_MESSAGE" VARCHAR2(500 BYTE) VISIBLE,
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "EXCEPTION_INFO" VARCHAR2(2000 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_LOG_ID" IS '日志主键seq_sys_job_log.nextval';
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_NAME" IS '任务名称';
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_GROUP" IS '任务组名';
COMMENT ON COLUMN "SYS_JOB_LOG"."INVOKE_TARGET" IS '调用目标字符串';
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_MESSAGE" IS '日志信息';
COMMENT ON COLUMN "SYS_JOB_LOG"."STATUS" IS '执行状态（0正常 1失败）';
COMMENT ON COLUMN "SYS_JOB_LOG"."EXCEPTION_INFO" IS '异常信息';
COMMENT ON COLUMN "SYS_JOB_LOG"."CREATE_TIME" IS '创建时间';
COMMENT ON TABLE "SYS_JOB_LOG" IS '定时任务调度日志表';

-- ----------------------------
-- Records of SYS_JOB_LOG
-- ----------------------------

-- ----------------------------
-- Table structure for SYS_LOGININFOR
-- ----------------------------

CREATE TABLE "SYS_LOGININFOR" (
  "INFO_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "LOGIN_NAME" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "IPADDR" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "LOGIN_LOCATION" VARCHAR2(255 BYTE) VISIBLE DEFAULT '',
  "BROWSER" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "OS" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "MSG" VARCHAR2(255 BYTE) VISIBLE DEFAULT '',
  "LOGIN_TIME" DATE VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_LOGININFOR"."INFO_ID" IS '访问主键seq_seq_sys_logininfor.nextval';
COMMENT ON COLUMN "SYS_LOGININFOR"."LOGIN_NAME" IS '登录账号';
COMMENT ON COLUMN "SYS_LOGININFOR"."IPADDR" IS '登录IP地址';
COMMENT ON COLUMN "SYS_LOGININFOR"."LOGIN_LOCATION" IS '登录地点';
COMMENT ON COLUMN "SYS_LOGININFOR"."BROWSER" IS '浏览器类型';
COMMENT ON COLUMN "SYS_LOGININFOR"."OS" IS '操作系统';
COMMENT ON COLUMN "SYS_LOGININFOR"."STATUS" IS '登录状态（0成功 1失败）';
COMMENT ON COLUMN "SYS_LOGININFOR"."MSG" IS '提示消息';
COMMENT ON COLUMN "SYS_LOGININFOR"."LOGIN_TIME" IS '访问时间';
COMMENT ON TABLE "SYS_LOGININFOR" IS '系统访问记录';

-- ----------------------------
-- Records of SYS_LOGININFOR
-- ----------------------------

-- ----------------------------
-- Table structure for SYS_MENU
-- ----------------------------

CREATE TABLE "SYS_MENU" (
  "MENU_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "MENU_NAME" VARCHAR2(50 BYTE) VISIBLE NOT NULL,
  "PARENT_ID" NUMBER(20,0) VISIBLE DEFAULT 0,
  "ORDER_NUM" NUMBER(4,0) VISIBLE DEFAULT 0,
  "URL" VARCHAR2(200 BYTE) VISIBLE DEFAULT '#',
  "TARGET" VARCHAR2(20 BYTE) VISIBLE DEFAULT '',
  "MENU_TYPE" CHAR(1 BYTE) VISIBLE DEFAULT '',
  "VISIBLE" CHAR(1 BYTE) VISIBLE DEFAULT 0,
  "PERMS" VARCHAR2(100 BYTE) VISIBLE DEFAULT NULL,
  "ICON" VARCHAR2(100 BYTE) VISIBLE DEFAULT '#',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE DEFAULT ''
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_MENU"."MENU_ID" IS '菜单主键seq_sys_post.nextval';
COMMENT ON COLUMN "SYS_MENU"."MENU_NAME" IS '菜单名称';
COMMENT ON COLUMN "SYS_MENU"."PARENT_ID" IS '父菜单ID';
COMMENT ON COLUMN "SYS_MENU"."ORDER_NUM" IS '显示顺序';
COMMENT ON COLUMN "SYS_MENU"."URL" IS '请求地址';
COMMENT ON COLUMN "SYS_MENU"."TARGET" IS '打开方式（menuItem页签 menuBlank新窗口）';
COMMENT ON COLUMN "SYS_MENU"."MENU_TYPE" IS '菜单类型（M目录 C菜单 F按钮）';
COMMENT ON COLUMN "SYS_MENU"."VISIBLE" IS '菜单状态（0显示 1隐藏）';
COMMENT ON COLUMN "SYS_MENU"."PERMS" IS '权限标识';
COMMENT ON COLUMN "SYS_MENU"."ICON" IS '菜单图标';
COMMENT ON COLUMN "SYS_MENU"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_MENU"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_MENU"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_MENU"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_MENU"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_MENU" IS '菜单权限表';

-- ----------------------------
-- Records of SYS_MENU
-- ----------------------------
INSERT INTO "SYS_MENU" VALUES ('1040', '操作删除', '500', '2', '#', NULL, 'F', '0', 'monitor:operlog:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1041', '详细信息', '500', '3', '#', NULL, 'F', '0', 'monitor:operlog:detail', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1042', '日志导出', '500', '4', '#', NULL, 'F', '0', 'monitor:operlog:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1043', '登录查询', '501', '1', '#', NULL, 'F', '0', 'monitor:logininfor:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1044', '登录删除', '501', '2', '#', NULL, 'F', '0', 'monitor:logininfor:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1045', '日志导出', '501', '3', '#', NULL, 'F', '0', 'monitor:logininfor:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1046', '账户解锁', '501', '4', '#', NULL, 'F', '0', 'monitor:logininfor:unlock', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1047', '在线查询', '109', '1', '#', NULL, 'F', '0', 'monitor:online:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1048', '批量强退', '109', '2', '#', NULL, 'F', '0', 'monitor:online:batchForceLogout', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1049', '单条强退', '109', '3', '#', NULL, 'F', '0', 'monitor:online:forceLogout', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1050', '任务查询', '110', '1', '#', NULL, 'F', '0', 'monitor:job:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1051', '任务新增', '110', '2', '#', NULL, 'F', '0', 'monitor:job:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1052', '任务修改', '110', '3', '#', NULL, 'F', '0', 'monitor:job:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1053', '任务删除', '110', '4', '#', NULL, 'F', '0', 'monitor:job:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1054', '状态修改', '110', '5', '#', NULL, 'F', '0', 'monitor:job:changeStatus', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1055', '任务详细', '110', '6', '#', NULL, 'F', '0', 'monitor:job:detail', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1056', '任务导出', '110', '7', '#', NULL, 'F', '0', 'monitor:job:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2127', '智能匹配', '2109', '6', '#', 'menuItem', 'F', '0', 'system:comp_info:matching', '#', 'admin', TO_DATE('2020-07-03 09:38:20', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 09:41:26', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2128', '查看成员', '2110', '1', '#', 'menuItem', 'F', '0', 'system:comp_team_mem:list', '#', 'admin', TO_DATE('2020-07-03 09:51:03', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 09:53:14', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2151', '查看成员', '2130', '0', '#', 'menuItem', 'F', '0', 'system:comp_team:edit', '#', 'admin', TO_DATE('2020-07-06 03:21:39', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_MENU" VALUES ('2150', '退出团队', '2130', '1', '#', 'menuItem', 'F', '0', 'system:comp_team_mem:exitTeam', '#', 'admin', TO_DATE('2020-07-06 03:04:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_MENU" VALUES ('2152', '创建团队', '2109', '7', '#', 'menuItem', 'F', '0', 'system:comp_team:add', '#', 'admin', TO_DATE('2020-07-06 03:25:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_MENU" VALUES ('2130', '查看团队', '2161', '4', '/system/comp_team/list1', 'menuItem', 'C', '0', 'system:comp_team:listbyuser', '#', 'admin', TO_DATE('2020-07-04 04:27:49', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-06 01:41:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2109', '竞赛属性', '2161', '1', '/system/comp_info', 'menuItem', 'C', '0', 'system:comp_info:view', '#', 'admin', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 09:42:02', 'SYYYY-MM-DD HH24:MI:SS'), '竞赛属性菜单');
INSERT INTO "SYS_MENU" VALUES ('2112', '竞赛属性查询', '2109', '1', '#', NULL, 'F', '0', 'system:comp_info:list', '#', 'admin', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2113', '竞赛属性新增', '2109', '2', '#', NULL, 'F', '0', 'system:comp_info:add', '#', 'admin', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2114', '竞赛属性修改', '2109', '3', '#', NULL, 'F', '0', 'system:comp_info:edit', '#', 'admin', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2115', '竞赛属性删除', '2109', '4', '#', NULL, 'F', '0', 'system:comp_info:remove', '#', 'admin', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2116', '竞赛属性导出', '2109', '5', '#', NULL, 'F', '0', 'system:comp_info:export', '#', 'admin', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2110', '团队成员', '2161', '3', '/system/comp_team_mem', 'menuItem', 'C', '1', 'system:comp_team_mem:view', '#', 'admin', TO_DATE('2020-06-16 04:12:51', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 09:42:29', 'SYYYY-MM-DD HH24:MI:SS'), '团队成员菜单');
INSERT INTO "SYS_MENU" VALUES ('2161', '竞赛管理', '0', '2', '#', 'menuItem', 'M', '0', NULL, 'fa fa-bank', 'admin', TO_DATE('2020-06-28 09:48:04', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 10:17:42', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2118', '团队成员新增', '2110', '2', '#', NULL, 'F', '0', 'system:comp_team_mem:add', '#', 'admin', TO_DATE('2020-06-16 04:12:51', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:51', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2120', '团队成员删除', '2110', '4', '#', NULL, 'F', '0', 'system:comp_team_mem:remove', '#', 'admin', TO_DATE('2020-06-16 04:12:51', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:51', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2121', '团队成员导出', '2110', '5', '#', NULL, 'F', '0', 'system:comp_team_mem:export', '#', 'admin', TO_DATE('2020-06-16 04:12:51', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:12:51', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2111', '团队管理', '2161', '2', '/system/comp_team', 'menuItem', 'C', '0', 'system:comp_team:view', '#', 'admin', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 09:59:09', 'SYYYY-MM-DD HH24:MI:SS'), '竞赛团队菜单');
INSERT INTO "SYS_MENU" VALUES ('2122', '竞赛团队查询', '2111', '1', '#', NULL, 'F', '0', 'system:comp_team:list', '#', 'admin', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2123', '竞赛团队新增', '2111', '2', '#', NULL, 'F', '0', 'system:comp_team:add', '#', 'admin', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2124', '竞赛团队修改', '2111', '3', '#', NULL, 'F', '0', 'system:comp_team:edit', '#', 'admin', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2125', '竞赛团队删除', '2111', '4', '#', NULL, 'F', '0', 'system:comp_team:remove', '#', 'admin', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('2126', '竞赛团队导出', '2111', '5', '#', NULL, 'F', '0', 'system:comp_team:export', '#', 'admin', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2020-06-16 04:13:02', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1', '系统管理', '0', '1', '#', NULL, 'M', '0', NULL, 'fa fa-gear', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '系统管理目录');
INSERT INTO "SYS_MENU" VALUES ('2', '系统监控', '0', '4', '#', 'menuItem', 'M', '0', NULL, 'fa fa-video-camera', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-04-16 04:16:04', 'SYYYY-MM-DD HH24:MI:SS'), '系统监控目录');
INSERT INTO "SYS_MENU" VALUES ('100', '用户管理', '1', '1', '/system/user', 'menuItem', 'C', '0', 'system:user:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-07 05:57:57', 'SYYYY-MM-DD HH24:MI:SS'), '用户管理菜单');
INSERT INTO "SYS_MENU" VALUES ('101', '角色管理', '1', '2', '/system/role', NULL, 'C', '0', 'system:role:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '角色管理菜单');
INSERT INTO "SYS_MENU" VALUES ('102', '菜单管理', '1', '3', '/system/menu', NULL, 'C', '0', 'system:menu:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '菜单管理菜单');
INSERT INTO "SYS_MENU" VALUES ('103', '部门管理', '1', '4', '/system/dept', NULL, 'C', '0', 'system:dept:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '部门管理菜单');
INSERT INTO "SYS_MENU" VALUES ('104', '岗位管理', '1', '5', '/system/post', NULL, 'C', '0', 'system:post:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '岗位管理菜单');
INSERT INTO "SYS_MENU" VALUES ('105', '字典管理', '1', '6', '/system/dict', NULL, 'C', '0', 'system:dict:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '字典管理菜单');
INSERT INTO "SYS_MENU" VALUES ('106', '参数设置', '1', '7', '/system/config', NULL, 'C', '0', 'system:config:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '参数设置菜单');
INSERT INTO "SYS_MENU" VALUES ('107', '通知公告', '1', '8', '/system/notice', NULL, 'C', '0', 'system:notice:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '通知公告菜单');
INSERT INTO "SYS_MENU" VALUES ('108', '日志管理', '1', '9', '#', NULL, 'M', '0', NULL, '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '日志管理菜单');
INSERT INTO "SYS_MENU" VALUES ('109', '在线用户', '2', '1', '/monitor/online', NULL, 'C', '0', 'monitor:online:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '在线用户菜单');
INSERT INTO "SYS_MENU" VALUES ('110', '定时任务', '2', '2', '/monitor/job', NULL, 'C', '0', 'monitor:job:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '定时任务菜单');
INSERT INTO "SYS_MENU" VALUES ('111', '数据监控', '2', '3', '/monitor/data', NULL, 'C', '0', 'monitor:data:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '数据监控菜单');
INSERT INTO "SYS_MENU" VALUES ('112', '服务监控', '2', '3', '/monitor/server', NULL, 'C', '0', 'monitor:server:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '服务监控菜单');
INSERT INTO "SYS_MENU" VALUES ('500', '操作日志', '108', '1', '/monitor/operlog', NULL, 'C', '0', 'monitor:operlog:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '操作日志菜单');
INSERT INTO "SYS_MENU" VALUES ('501', '登录日志', '108', '2', '/monitor/logininfor', NULL, 'C', '0', 'monitor:logininfor:view', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), '登录日志菜单');
INSERT INTO "SYS_MENU" VALUES ('1000', '用户查询', '100', '1', '#', NULL, 'F', '0', 'system:user:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1001', '用户新增', '100', '2', '#', NULL, 'F', '0', 'system:user:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1002', '用户修改', '100', '3', '#', NULL, 'F', '0', 'system:user:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1003', '用户删除', '100', '4', '#', NULL, 'F', '0', 'system:user:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1004', '用户导出', '100', '5', '#', NULL, 'F', '0', 'system:user:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1005', '用户导入', '100', '6', '#', NULL, 'F', '0', 'system:user:import', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1006', '重置密码', '100', '7', '#', NULL, 'F', '0', 'system:user:resetPwd', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1007', '角色查询', '101', '1', '#', NULL, 'F', '0', 'system:role:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1008', '角色新增', '101', '2', '#', NULL, 'F', '0', 'system:role:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1009', '角色修改', '101', '3', '#', NULL, 'F', '0', 'system:role:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1010', '角色删除', '101', '4', '#', NULL, 'F', '0', 'system:role:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1011', '角色导出', '101', '5', '#', NULL, 'F', '0', 'system:role:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1012', '菜单查询', '102', '1', '#', NULL, 'F', '0', 'system:menu:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1013', '菜单新增', '102', '2', '#', NULL, 'F', '0', 'system:menu:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1014', '菜单修改', '102', '3', '#', NULL, 'F', '0', 'system:menu:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1015', '菜单删除', '102', '4', '#', NULL, 'F', '0', 'system:menu:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1016', '部门查询', '103', '1', '#', NULL, 'F', '0', 'system:dept:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1017', '部门新增', '103', '2', '#', NULL, 'F', '0', 'system:dept:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1018', '部门修改', '103', '3', '#', NULL, 'F', '0', 'system:dept:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1019', '部门删除', '103', '4', '#', NULL, 'F', '0', 'system:dept:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1020', '岗位查询', '104', '1', '#', NULL, 'F', '0', 'system:post:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1021', '岗位新增', '104', '2', '#', NULL, 'F', '0', 'system:post:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1022', '岗位修改', '104', '3', '#', NULL, 'F', '0', 'system:post:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1023', '岗位删除', '104', '4', '#', NULL, 'F', '0', 'system:post:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1024', '岗位导出', '104', '5', '#', NULL, 'F', '0', 'system:post:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1025', '字典查询', '105', '1', '#', NULL, 'F', '0', 'system:dict:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1026', '字典新增', '105', '2', '#', NULL, 'F', '0', 'system:dict:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1027', '字典修改', '105', '3', '#', NULL, 'F', '0', 'system:dict:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1028', '字典删除', '105', '4', '#', NULL, 'F', '0', 'system:dict:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1029', '字典导出', '105', '5', '#', NULL, 'F', '0', 'system:dict:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1030', '参数查询', '106', '1', '#', NULL, 'F', '0', 'system:config:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1031', '参数新增', '106', '2', '#', NULL, 'F', '0', 'system:config:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1032', '参数修改', '106', '3', '#', NULL, 'F', '0', 'system:config:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1033', '参数删除', '106', '4', '#', NULL, 'F', '0', 'system:config:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1034', '参数导出', '106', '5', '#', NULL, 'F', '0', 'system:config:export', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1035', '公告查询', '107', '1', '#', NULL, 'F', '0', 'system:notice:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1036', '公告新增', '107', '2', '#', NULL, 'F', '0', 'system:notice:add', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1037', '公告修改', '107', '3', '#', NULL, 'F', '0', 'system:notice:edit', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1038', '公告删除', '107', '4', '#', NULL, 'F', '0', 'system:notice:remove', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_MENU" VALUES ('1039', '操作查询', '500', '1', '#', NULL, 'F', '0', 'monitor:operlog:list', '#', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);

-- ----------------------------
-- Table structure for SYS_NOTICE
-- ----------------------------

CREATE TABLE "SYS_NOTICE" (
  "NOTICE_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "NOTICE_TITLE" VARCHAR2(2000 BYTE) VISIBLE NOT NULL,
  "NOTICE_TYPE" CHAR(1 BYTE) VISIBLE NOT NULL,
  "NOTICE_CONTENT" VARCHAR2(4000 BYTE) VISIBLE DEFAULT NULL,
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(255 BYTE) VISIBLE DEFAULT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_ID" IS '公告主键seq_sys_notice.nextval';
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_TITLE" IS '公告标题';
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_TYPE" IS '公告类型（1通知 2公告）';
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_CONTENT" IS '公告内容';
COMMENT ON COLUMN "SYS_NOTICE"."STATUS" IS '公告状态（0正常 1关闭）';
COMMENT ON COLUMN "SYS_NOTICE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_NOTICE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_NOTICE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_NOTICE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_NOTICE"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_NOTICE" IS '通知公告表';

-- ----------------------------
-- Records of SYS_NOTICE
-- ----------------------------
INSERT INTO "SYS_NOTICE" VALUES ('2', '信息学院学生在第44届ICPC国际大学生程序设计竞赛亚洲区域赛喜获铜奖', '2', '<p class="vsbcontent_start" style="text-align: center; line-height: 21px; text-indent: 2em; font-size: 14px; color: rgb(71, 71, 71); font-family: 宋体;"><img src="http://sist.lnu.edu.cn/__local/3/C4/7B/8038CBE0FEC33015A18A2EF6688_F0524630_429B5.png" style="width: 503px;"><span style="text-indent: 2em;"><br></span></p><p class="vsbcontent_start" style="line-height: 21px; text-indent: 2em; font-size: 14px; color: rgb(71, 71, 71); font-family: 宋体;"><span style="text-indent: 2em;">近期,第44届ICPC国际大学生程序设计竞赛亚洲区域赛在南京航空航天大学举行。经过今年9月份网络赛的激烈选拔，共有来自包括北京大学、清华大学、浙江大学和上海交通大学等在内的全国176所高校的334支队伍参赛。我校信息学院的计算机科学与技术和软件工程专业的三位同学组成一支代表队，代表学校参赛。经过5个小时的现场激烈角逐，三位选手不畏强手，勇于拼搏，最终获得铜奖。此次获奖体现了我校对学生创新能力和实践能力培养的高度重视和精准引领，是学校紧抓人才培养模式改革，全面深化教育教学综合改革的成果体现。</span><br></p><p style="line-height: 21px; text-indent: 2em; font-size: 14px; color: rgb(71, 71, 71); font-family: 宋体;">ICPC国际大学生程序设计竞赛是旨在展示大学生创新能力、团队精神和在压力下编写程序、分析和解决问题能力的年度竞赛。竞赛始于1970年，成形于1977年，迄今已经成功举办了44届，是当今国际计算机界历史悠久并得到全球公认的规模最大、水平最高的国际大学生程序设计竞赛，被誉为计算机软件领域的奥林匹克竞赛，也是最受计算机行业认可的权威性的竞赛。</p><p style="line-height: 21px; text-indent: 2em; font-size: 14px; color: rgb(71, 71, 71); font-family: 宋体;">多年来，信息学院一直秉承“明德精学，笃行致强”的校训精神，以学科建设为龙头，以提高教学质量为核心，以社会化需求为导向，以人才培养为宗旨，不断调整课程结构、完善教学体系，提出学科竞赛作为教学的延伸，借助专业社团为平台，依托教学改革项目，组织了一批一线教师将课堂教学延伸到学科竞赛的训练和指导中，积极参加学科竞赛，充分保障竞赛所需经费和场地，在各项高水平学科竞赛中屡创佳绩，彰显了实践育人的累累硕果。</p><p style="text-align: center; line-height: 21px; text-indent: 2em; font-size: 14px; color: rgb(71, 71, 71); font-family: 宋体;"><img src="http://sist.lnu.edu.cn/__local/2/B0/EC/84C0D172A1A2B5DBBC94C89013C_5BF4B436_5F088.png" style="width: 429px;"><br></p>', '0', 'admin', TO_DATE('2020-07-07 02:45:50', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-07 04:08:56', 'SYYYY-MM-DD HH24:MI:SS'), NULL);

-- ----------------------------
-- Table structure for SYS_OPER_LOG
-- ----------------------------

CREATE TABLE "SYS_OPER_LOG" (
  "OPER_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "TITLE" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "BUSINESS_TYPE" NUMBER(2,0) VISIBLE DEFAULT 0,
  "METHOD" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "REQUEST_METHOD" VARCHAR2(10 BYTE) VISIBLE DEFAULT '',
  "OPERATOR_TYPE" NUMBER(1,0) VISIBLE DEFAULT 0,
  "OPER_NAME" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "DEPT_NAME" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "OPER_URL" VARCHAR2(255 BYTE) VISIBLE DEFAULT '',
  "OPER_IP" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "OPER_LOCATION" VARCHAR2(255 BYTE) VISIBLE DEFAULT '',
  "OPER_PARAM" VARCHAR2(4000 BYTE) VISIBLE DEFAULT '',
  "JSON_RESULT" VARCHAR2(4000 BYTE) VISIBLE DEFAULT '',
  "STATUS" NUMBER(1,0) VISIBLE DEFAULT 0,
  "ERROR_MSG" VARCHAR2(4000 BYTE) VISIBLE DEFAULT '',
  "OPER_TIME" DATE VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_ID" IS '日志主键seq_sys_oper_log.nextval';
COMMENT ON COLUMN "SYS_OPER_LOG"."TITLE" IS '模块标题';
COMMENT ON COLUMN "SYS_OPER_LOG"."BUSINESS_TYPE" IS '业务类型（0其它 1新增 2修改 3删除）';
COMMENT ON COLUMN "SYS_OPER_LOG"."METHOD" IS '方法名称';
COMMENT ON COLUMN "SYS_OPER_LOG"."REQUEST_METHOD" IS '请求方式';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPERATOR_TYPE" IS '操作类别（0其它 1后台用户 2手机端用户）';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_NAME" IS '操作人员';
COMMENT ON COLUMN "SYS_OPER_LOG"."DEPT_NAME" IS '部门名称';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_URL" IS '请求URL';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_IP" IS '主机地址';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_LOCATION" IS '操作地点';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_PARAM" IS '请求参数';
COMMENT ON COLUMN "SYS_OPER_LOG"."JSON_RESULT" IS '返回参数';
COMMENT ON COLUMN "SYS_OPER_LOG"."STATUS" IS '操作状态（0正常 1异常）';
COMMENT ON COLUMN "SYS_OPER_LOG"."ERROR_MSG" IS '错误消息';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_TIME" IS '操作时间';
COMMENT ON TABLE "SYS_OPER_LOG" IS '操作日志记录';

-- ----------------------------
-- Records of SYS_OPER_LOG
-- ----------------------------

-- ----------------------------
-- Table structure for SYS_POST
-- ----------------------------

CREATE TABLE "SYS_POST" (
  "POST_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "POST_CODE" VARCHAR2(64 BYTE) VISIBLE NOT NULL,
  "POST_NAME" VARCHAR2(50 BYTE) VISIBLE NOT NULL,
  "POST_SORT" NUMBER(4,0) VISIBLE NOT NULL,
  "STATUS" CHAR(1 BYTE) VISIBLE NOT NULL,
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_POST"."POST_ID" IS '岗位主键seq_sys_post.nextval';
COMMENT ON COLUMN "SYS_POST"."POST_CODE" IS '岗位编码';
COMMENT ON COLUMN "SYS_POST"."POST_NAME" IS '岗位名称';
COMMENT ON COLUMN "SYS_POST"."POST_SORT" IS '显示顺序';
COMMENT ON COLUMN "SYS_POST"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_POST"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_POST"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_POST"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_POST"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_POST"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_POST" IS '岗位信息表';

-- ----------------------------
-- Records of SYS_POST
-- ----------------------------
INSERT INTO "SYS_POST" VALUES ('1', 'admin', '管理员', '1', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_POST" VALUES ('3', 'stu', '学生', '3', '0', 'admin', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), 'ry', TO_DATE('2018-03-16 11:33:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL);

-- ----------------------------
-- Table structure for SYS_ROLE
-- ----------------------------

CREATE TABLE "SYS_ROLE" (
  "ROLE_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "ROLE_NAME" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "ROLE_KEY" VARCHAR2(100 BYTE) VISIBLE NOT NULL,
  "ROLE_SORT" NUMBER(4,0) VISIBLE NOT NULL,
  "DATA_SCOPE" CHAR(1 BYTE) VISIBLE DEFAULT '1',
  "STATUS" CHAR(1 BYTE) VISIBLE NOT NULL,
  "DEL_FLAG" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE DEFAULT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_ROLE"."ROLE_ID" IS '角色主键seq_sys_post.nextval';
COMMENT ON COLUMN "SYS_ROLE"."ROLE_NAME" IS '角色名称';
COMMENT ON COLUMN "SYS_ROLE"."ROLE_KEY" IS '角色权限字符串';
COMMENT ON COLUMN "SYS_ROLE"."ROLE_SORT" IS '显示顺序';
COMMENT ON COLUMN "SYS_ROLE"."DATA_SCOPE" IS '数据范围（1：全部数据权限 2：自定数据权限）';
COMMENT ON COLUMN "SYS_ROLE"."STATUS" IS '角色状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_ROLE"."DEL_FLAG" IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN "SYS_ROLE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_ROLE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_ROLE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_ROLE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_ROLE"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_ROLE" IS '角色信息表';

-- ----------------------------
-- Records of SYS_ROLE
-- ----------------------------
INSERT INTO "SYS_ROLE" VALUES ('2', '管理', 'admin', '1', '1', '0', '0', 'admin', TO_DATE('2020-07-03 03:34:09', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-07 06:02:24', 'SYYYY-MM-DD HH24:MI:SS'), '管理员');
INSERT INTO "SYS_ROLE" VALUES ('3', '学生', 'common', '2', '5', '0', '0', 'admin', TO_DATE('2020-07-03 03:36:12', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-07 06:02:36', 'SYYYY-MM-DD HH24:MI:SS'), '学生');

-- ----------------------------
-- Table structure for SYS_ROLE_DEPT
-- ----------------------------

CREATE TABLE "SYS_ROLE_DEPT" (
  "ROLE_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "DEPT_ID" NUMBER(20,0) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_ROLE_DEPT"."ROLE_ID" IS '角色ID';
COMMENT ON COLUMN "SYS_ROLE_DEPT"."DEPT_ID" IS '部门ID';
COMMENT ON TABLE "SYS_ROLE_DEPT" IS '角色和部门关联表';

-- ----------------------------
-- Records of SYS_ROLE_DEPT
-- ----------------------------

-- ----------------------------
-- Table structure for SYS_ROLE_MENU
-- ----------------------------

CREATE TABLE "SYS_ROLE_MENU" (
  "ROLE_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "MENU_ID" NUMBER(20,0) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_ROLE_MENU"."ROLE_ID" IS '角色ID';
COMMENT ON COLUMN "SYS_ROLE_MENU"."MENU_ID" IS '菜单ID';
COMMENT ON TABLE "SYS_ROLE_MENU" IS '角色和菜单关联表';

-- ----------------------------
-- Records of SYS_ROLE_MENU
-- ----------------------------
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1035');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1036');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1037');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1038');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1039');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1040');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1041');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1042');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1043');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1044');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1045');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1046');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1047');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1048');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1049');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1050');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1051');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1052');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1053');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1054');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1055');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1056');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1057');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1058');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1059');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1060');
INSERT INTO "SYS_ROLE_MENU" VALUES ('1', '1061');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '100');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1000');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1001');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1002');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1003');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1004');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1005');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1006');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '101');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1007');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1008');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1009');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1010');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1011');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '102');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1012');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1013');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1014');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1015');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '103');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1016');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1017');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1018');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1019');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '104');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1020');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1021');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1022');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1023');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1024');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '105');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1025');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1026');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1027');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1028');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1029');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '106');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1030');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1031');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1032');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1033');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1034');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '107');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1035');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1036');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1037');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1038');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '108');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '500');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1039');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1040');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1041');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1042');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '501');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1043');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1044');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1045');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1046');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2161');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2109');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2112');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2113');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2114');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2115');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2116');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2111');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2122');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2123');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2124');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2125');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2126');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2110');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2128');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2118');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2120');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2121');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '2');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '109');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1047');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1048');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1049');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '110');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1050');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1051');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1052');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1053');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1054');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1055');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '1056');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '111');
INSERT INTO "SYS_ROLE_MENU" VALUES ('2', '112');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '1');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '107');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '1035');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2161');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2109');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2112');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2152');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2110');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2128');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2118');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2120');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2130');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2151');
INSERT INTO "SYS_ROLE_MENU" VALUES ('3', '2150');

-- ----------------------------
-- Table structure for SYS_USER
-- ----------------------------

CREATE TABLE "SYS_USER" (
  "USER_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "DEPT_ID" NUMBER(20,0) VISIBLE DEFAULT NULL,
  "LOGIN_NAME" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "USER_NAME" VARCHAR2(30 BYTE) VISIBLE DEFAULT '',
  "USER_TYPE" VARCHAR2(2 BYTE) VISIBLE DEFAULT '00',
  "EMAIL" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "PHONENUMBER" VARCHAR2(11 BYTE) VISIBLE DEFAULT '',
  "SEX" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "AVATAR" VARCHAR2(100 BYTE) VISIBLE DEFAULT '',
  "PASSWORD" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "SALT" VARCHAR2(20 BYTE) VISIBLE DEFAULT '',
  "STATUS" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "DEL_FLAG" CHAR(1 BYTE) VISIBLE DEFAULT '0',
  "LOGIN_IP" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "LOGIN_DATE" DATE VISIBLE,
  "CREATE_BY" VARCHAR2(64 BYTE) VISIBLE,
  "CREATE_TIME" DATE VISIBLE,
  "UPDATE_BY" VARCHAR2(64 BYTE) VISIBLE DEFAULT '',
  "UPDATE_TIME" DATE VISIBLE,
  "REMARK" VARCHAR2(500 BYTE) VISIBLE DEFAULT '',
  "TA" NUMBER VISIBLE,
  "PA" NUMBER VISIBLE,
  "CE" NUMBER VISIBLE,
  "LA" NUMBER VISIBLE,
  "CA" NUMBER VISIBLE,
  "AE" NUMBER VISIBLE,
  "GRADE" NUMBER VISIBLE,
  "MAJOR" VARCHAR2(100 BYTE) VISIBLE
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_USER"."USER_ID" IS '用户主键seq_sys_user.nextval';
COMMENT ON COLUMN "SYS_USER"."DEPT_ID" IS '部门ID';
COMMENT ON COLUMN "SYS_USER"."LOGIN_NAME" IS '登录账号';
COMMENT ON COLUMN "SYS_USER"."USER_NAME" IS '用户昵称';
COMMENT ON COLUMN "SYS_USER"."USER_TYPE" IS '用户类型（00系统用户 01注册用户）';
COMMENT ON COLUMN "SYS_USER"."EMAIL" IS '用户邮箱';
COMMENT ON COLUMN "SYS_USER"."PHONENUMBER" IS '手机号码';
COMMENT ON COLUMN "SYS_USER"."SEX" IS '用户性别（0男 1女 2未知）';
COMMENT ON COLUMN "SYS_USER"."AVATAR" IS '头像路径';
COMMENT ON COLUMN "SYS_USER"."PASSWORD" IS '密码';
COMMENT ON COLUMN "SYS_USER"."SALT" IS '盐加密';
COMMENT ON COLUMN "SYS_USER"."STATUS" IS '帐号状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_USER"."DEL_FLAG" IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN "SYS_USER"."LOGIN_IP" IS '最后登陆IP';
COMMENT ON COLUMN "SYS_USER"."LOGIN_DATE" IS '最后登陆时间';
COMMENT ON COLUMN "SYS_USER"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_USER"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_USER"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_USER"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_USER"."REMARK" IS '备注';
COMMENT ON COLUMN "SYS_USER"."TA" IS '理论能力';
COMMENT ON COLUMN "SYS_USER"."PA" IS '运用能力';
COMMENT ON COLUMN "SYS_USER"."CE" IS '竞赛经验';
COMMENT ON COLUMN "SYS_USER"."LA" IS '领导能力';
COMMENT ON COLUMN "SYS_USER"."CA" IS '协作能力';
COMMENT ON COLUMN "SYS_USER"."AE" IS '精力值';
COMMENT ON COLUMN "SYS_USER"."GRADE" IS '入学年份';
COMMENT ON COLUMN "SYS_USER"."MAJOR" IS '专业';
COMMENT ON TABLE "SYS_USER" IS '用户信息表';

-- ----------------------------
-- Records of SYS_USER
-- ----------------------------
INSERT INTO "SYS_USER" VALUES ('217', '222', '141403208', '温召成', '00', NULL, NULL, '0', NULL, '792883f0e99b1ed48b201d3c9bad51f1', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.71', '0.73', '0.17', '0.17', '0.37', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('218', '222', '141403209', '徐景松', '00', NULL, NULL, '0', NULL, '8fd4e55d735e6cf13cb444f926be295e', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.75', '0.76', '0.64', '0.64', '0.16', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('219', '222', '141403210', '齐传凯', '00', NULL, NULL, '0', NULL, 'c24cdafb690d79fb0be6500b4ebd24df', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.75', '0.61', '0.61', '0.44', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('220', '222', '141403211', '吴坤', '00', NULL, NULL, '0', NULL, '582acb1ef9294af600dce29bf7374e88', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.67', '0.77', '0.7', '0.7', '0.23', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('221', '222', '141403212', '郑瑞', '00', NULL, NULL, '0', NULL, '670170d03f1601b78ff8932a8a836e09', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.85', '0.79', '0.32', '0.32', '0.43', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('222', '222', '141403213', '赵浩亮', '00', NULL, NULL, '0', NULL, 'ce6c10b955d99f81baa62b39ba443141', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.83', '0.12', '0.12', '0.59', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('223', '222', '141403214', '赵纹萱', '00', NULL, NULL, '0', NULL, '45190e3e81abfd259593fafb03c3d4e7', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.78', '0.8', '0.62', '0.62', '0.46', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('224', '222', '141403215', '李燊', '00', NULL, NULL, '0', NULL, 'be00e7e636e4e9ff98bcc92e8edb251d', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.77', '0.56', '0.56', '0.12', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('225', '222', '141403216', '曾祥辉', '00', NULL, NULL, '0', NULL, '0bb851987cfea14ff8a92bf7913055eb', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.65', '0.7', '0.05', '0.05', '0.54', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('226', '222', '141403217', '张新刚', '00', NULL, NULL, '0', NULL, '9bdf0b9ff23e4c721656befd87c2865c', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.69', '0.72', '0.39', '0.39', '0.2', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('227', '222', '141403218', '田家辉', '00', NULL, NULL, '0', NULL, '9e0c9634ba9c51c05c6d33c4cc105c23', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.7', '0.78', '0.42', '0.42', '0.26', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('228', '222', '141403219', '王鹏杰', '00', NULL, NULL, '0', NULL, 'e26a872bd8ac63b4a1f7c7d6855c756d', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.71', '0.74', '0.52', '0.52', '0.48', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('229', '222', '141403220', '周云飞', '00', NULL, NULL, '0', NULL, 'bfe63c88a99bbb10df62a32da6059e8b', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.75', '0.78', '0.35', '0.35', '0.24', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('230', '222', '141403221', '孙博', '00', NULL, NULL, '0', NULL, 'e8d04745c149ebbb5d426136dfcf9977', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.73', '0.73', '0.42', '0.42', '0.16', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('231', '222', '141403222', '张卫汉', '00', NULL, NULL, '0', NULL, 'e3f0141fc9162be61c91c11c63a8cf26', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.97', '0.8', '0.3', '0.3', '0.2', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('232', '222', '141403223', '刘艺婷', '00', NULL, NULL, '1', NULL, 'ac4748cbaecda29a2ab6646a951fb26a', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.79', '0.53', '0.53', '0.11', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('233', '222', '141403224', '王烨', '00', NULL, NULL, '1', NULL, '88bf02231bbf39186c6f6caf75340cf2', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.91', '0.85', '0.49', '0.49', '0.22', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('234', '222', '141403225', '曲玫宇', '00', NULL, NULL, '1', NULL, '7b202cae3a4761a75cd0929966a8c49e', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.68', '0.77', '0.63', '0.63', '0.16', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('235', '222', '141403226', '贾亦菲', '00', NULL, NULL, '1', NULL, '5ca78e8f8739a8171dea16125ac6c1fa', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.81', '0.84', '0.23', '0.23', '0.48', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('236', '222', '141403227', '丁蕊', '00', NULL, NULL, '1', NULL, 'c81afffd138d2ccf5e9fe7946ec6e5dc', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.86', '0.9', '0.53', '0.53', '0.15', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('237', '222', '141403228', '唐思琪', '00', NULL, NULL, '1', NULL, '52b86529b64b0b3fc4b278eaeb028e39', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.73', '0.76', '0.15', '0.15', '0.54', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('238', '222', '141403229', '宁春梅', '00', NULL, NULL, '1', NULL, '4f55cb8f0cc30c235934b76cf4183534', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.73', '0.72', '0.04', '0.04', '0.01', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('239', '222', '141403230', '阿贤惠', '00', NULL, NULL, '1', NULL, '1d1d4b2209521821b3d53398bbd2a118', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.69', '0.78', '0.69', '0.69', '0.46', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('240', '222', '141403301', '顾德欣', '00', NULL, NULL, '0', NULL, '512b7bbe38d2b72a9d86d162748b81c3', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.58', '0.65', '0.59', '0.59', '0.22', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('241', '222', '141403302', '邓洋洋', '00', NULL, NULL, '0', NULL, 'c39ee52eda1871ef8a9bb0a2abeff439', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.8', '0.14', '0.14', '0.13', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('242', '222', '141403303', '于桐宇', '00', NULL, NULL, '0', NULL, '8ddfb692fa14213a46725d43080632a7', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.68', '0.74', '0.68', '0.68', '0.46', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('1', '103', 'admin', '管理员', '00', 'admin@admin.com', '13333333333', '0', '/profile/avatar/2020/07/06/dad5ba70004fede3d060ad8425f632bd.png', '93c3cbabcb710d0e7269b66b9b706391', 'e9f26a', '0', '0', '127.0.0.1', TO_DATE('2020-07-07 11:13:57', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 02:46:51', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-07 03:13:57', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('21', '204', '4031732048', '吴松林', '00', 'songlinwu8@163.com', '13555715986', '0', '/profile/avatar/2020/07/06/dad5ba70004fede3d060ad8425f632bd.png', '7fc313bb9d1e7f979afc545c61b672fa', '2b0cb0', '0', '0', '127.0.0.1', TO_DATE('2020-07-07 09:35:24', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-07-03 03:37:56', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2020-07-07 01:35:25', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '0.3', '0.6', '0.7', '0.2', '0.3', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('246', '222', '141403307', '邱德胜', '00', NULL, NULL, '0', NULL, 'e99e627666a2366a2f2c9ef3edb7a853', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.74', '0.8', '0.27', '0.27', '0.29', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('247', '222', '141403308', '乔源', '00', NULL, NULL, '0', NULL, 'a43dd74f34a8074f83688c85f6cba529', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.6', '0.73', '0.65', '0.65', '0.03', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('248', '222', '141403309', '张国彬', '00', NULL, NULL, '0', NULL, 'e839630fdf0ea2bf373d327b3b07703a', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.71', '0.64', '0.45', '0.45', '0.26', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('249', '222', '141403310', '祝兴健', '00', NULL, NULL, '0', NULL, '84967c8f1819705a89ffa45639dfadfa', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.77', '0.43', '0.43', '0.28', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('250', '222', '141403311', '王思鞍', '00', NULL, NULL, '0', NULL, '97db043f9f6c9f4a0a00f2dc5572a1a3', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.68', '0.7', '0.45', '0.45', '0.07', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('251', '222', '141403312', '朱嘉琦', '00', NULL, NULL, '0', NULL, '1c633ec1104304c820f305539017689d', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.54', '0.66', '0.51', '0.51', '0.49', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('252', '222', '141403313', '韩海', '00', NULL, NULL, '0', NULL, '81b046cb113b248f06871d582ab02618', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.56', '0.67', '0.62', '0.62', '0.19', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('253', '222', '141403314', '尹鹏宇', '00', NULL, NULL, '0', NULL, 'b7fb349f1ac6d79b197b7b0c04993c3a', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.61', '0.66', '0.7', '0.7', '0.09', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('254', '222', '141403315', '李志鹏', '00', NULL, NULL, '0', NULL, '45db5ffd1a5d8a7d7858fa025867dd80', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.71', '0.72', '0.19', '0.19', '0.12', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('255', '222', '141403316', '杨世平', '00', NULL, NULL, '0', NULL, '93ff32bbb06594392e9a4325c31ab6ee', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.59', '0.65', '0.38', '0.38', '0.12', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('256', '222', '141403317', '陆人杰', '00', NULL, NULL, '0', NULL, '6712fada80addefeb8cc26d4b5b460fb', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.79', '0.77', '0.33', '0.33', '0.37', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('257', '222', '141403318', '邱泽鹏', '00', NULL, NULL, '0', NULL, '9c40e2836860bd07ceecaeeb2a738d46', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.54', '0.62', '0.69', '0.69', '0.47', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('258', '222', '141403319', '袁兵祥', '00', NULL, NULL, '0', NULL, 'd3be3ffaaa6240cda1df47b689945b1b', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.75', '0.08', '0.08', '0.49', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('259', '222', '141403320', '张亦夫', '00', NULL, NULL, '0', NULL, '867c6be616cc40cb6d81bacbe97fc838', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.64', '0.25', '0.25', '0.46', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('260', '222', '141403321', '张嘉鑫', '00', NULL, NULL, '0', NULL, 'c5e9a8c604cfe6b622192af43b2f4e19', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.8', '0.42', '0.42', '0.34', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('261', '222', '141403322', '尚柯', '00', NULL, NULL, '0', NULL, 'fdc0b791179e1ff25a8ed9353d5c5228', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.65', '0.66', '0.18', '0.18', '0.69', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('262', '222', '141403323', '秦晓丹', '00', NULL, NULL, '1', NULL, '05d6b3504d593641525ac2d3d04796ad', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.79', '0.84', '0.37', '0.37', '0.44', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('263', '222', '141403324', '唐佳莹', '00', NULL, NULL, '1', NULL, '62df64b8cf069f635352cc0dea8aaaf9', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.9', '0.87', '0.45', '0.45', '0.38', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('264', '222', '141403325', '胡宁', '00', NULL, NULL, '1', NULL, '52b09b75c9a2723b04aab7db5ad72934', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.87', '0.65', '0.65', '0.06', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('265', '222', '141403326', '兰宇晴', '00', NULL, NULL, '1', NULL, '0acb5f0bcc0c92e062410ad2f439a378', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.86', '0.1', '0.1', '0.18', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('266', '222', '141403327', '侯晴', '00', NULL, NULL, '1', NULL, '76462a9690a1f476c556c3b55b7ad0af', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.86', '0.86', '0.51', '0.51', '0.08', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('267', '222', '141403328', '郭青青', '00', NULL, NULL, '1', NULL, '5f8641e142712a04b5fc8f6e542f7971', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.79', '0.78', '0.16', '0.16', '0.23', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('268', '222', '141403329', '周小红', '00', NULL, NULL, '1', NULL, '2e5f90f99e10b96a30ac709e7878263b', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.89', '0.87', '0.38', '0.38', '0.6', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('269', '222', '141403330', '刘洁', '00', NULL, NULL, '1', NULL, 'da3086ec62cd992f7ba551241602affc', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.88', '0.84', '0.63', '0.63', '0.11', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('243', '222', '141403304', '杜家宝', '00', NULL, NULL, '0', NULL, '04b521b92e2b034d0baf82a6cba6528a', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.79', '0.29', '0.29', '0.09', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('244', '222', '141403305', '宫磊', '00', NULL, NULL, '0', NULL, '803fc4b3173c3c18a10a821146aa9fa3', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.74', '0.8', '0.12', '0.12', '0.23', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('182', '222', '141403101', '张翼', '00', NULL, NULL, '0', NULL, '660c11595a316aec79ec21a1f6c7735d', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.62', '0.71', '0.05', '0.05', '0.31', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('183', '222', '141403102', '关欣荣', '00', NULL, NULL, '0', NULL, '500d4e354c70fb714f03cdcd211f44c1', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.5', '0.55', '0.65', '0.65', '0.4', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('184', '222', '141403103', '吴昊', '00', NULL, NULL, '0', NULL, '89b3c71694c4c4cce36bdd4fa0a12c0e', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.64', '0.74', '0.39', '0.39', '0.19', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('185', '222', '141403104', '付成鹏', '00', NULL, NULL, '0', NULL, 'cf403fb6cd3ab666b57344d3990a3baa', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.89', '0.87', '0.42', '0.42', '0.21', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('186', '222', '141403105', '祝金思', '00', NULL, NULL, '0', NULL, 'e277e994a80e54495478bd473564ba6d', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.75', '0.77', '0.44', '0.44', '0.49', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('187', '222', '141403106', '孔相广', '00', NULL, NULL, '0', NULL, 'd31b386c93b8999313555161a73a5ada', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.98', '0.84', '0.01', '0.01', NULL, '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('188', '222', '141403107', '王长海', '00', NULL, NULL, '0', NULL, '778c3fabe55522d1af10f2252059fb59', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.88', '0.89', '0.68', '0.68', '0.16', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('189', '222', '141403108', '范广宇', '00', NULL, NULL, '0', NULL, 'c424e79496c6942c79d09aef65c5492e', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.75', '0.77', '0.28', '0.28', '0.2', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('190', '222', '141403109', '李做成', '00', NULL, NULL, '0', NULL, 'caccfc5988a3e9016b61ddb473e7c691', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.86', '0.84', '0.51', '0.51', '0.53', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('191', '222', '141403110', '霍鑫', '00', NULL, NULL, '0', NULL, 'e44c3172951be06639b07fded58701aa', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.61', '0.68', '0.31', '0.31', '0.19', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('192', '222', '141403111', '王旭', '00', NULL, NULL, '0', NULL, '9256cbc9e5dca59dffeddb9a6e8d0387', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.6', '0.63', '0.35', '0.35', '0.45', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('193', '222', '141403112', '张校铭', '00', NULL, NULL, '0', NULL, '7f8f4cf41afb6aa71870e2487e674f2a', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.96', '0.84', '0.42', '0.42', '0.13', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('194', '222', '141403113', '李佳乐', '00', NULL, NULL, '0', NULL, 'e5551e7311d006df718b8680bc6ec9ab', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.83', '0.26', '0.26', '0.1', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('195', '222', '141403114', '杨帆', '00', NULL, NULL, '0', NULL, 'c7929fe00be15f3cdb1285bdb42638af', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.64', '0.71', '0.42', '0.42', '0.32', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('196', '222', '141403115', '刘选浩', '00', NULL, NULL, '0', NULL, '2cb5e02a1dc36fe7d721912c25f8840d', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.87', '0.79', '0.63', '0.63', '0.21', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('197', '222', '141403116', '张建福', '00', NULL, NULL, '0', NULL, '566cba24f6d92f6fe5a10ce5d677b912', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.55', '0.66', '0.3', '0.3', '0.66', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('198', '222', '141403117', '刘一帆', '00', NULL, NULL, '0', NULL, '12e71b1decdcd08b4868b62e10b7a416', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.42', '0.52', '0.25', '0.25', '0.46', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('199', '222', '141403118', '李锴君', '00', NULL, NULL, '0', NULL, 'df62c06ccb78712c6d170b8f6219f79b', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.86', '0.74', '0.66', '0.66', '0.26', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('200', '222', '141403120', '靳文繁', '00', NULL, NULL, '0', NULL, '64c3386a1bad0aaf5fdc2d0359c59305', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.54', '0.68', '0.12', '0.12', '0.12', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('201', '222', '141403121', '张丹乔', '00', NULL, NULL, '0', NULL, '307849b57469fbba0e66e452c5f994d5', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.8', '0.59', '0.45', '0.45', '0.29', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('202', '222', '141403123', '朱玥', '00', NULL, NULL, '1', NULL, '8192dc8bdb72e21da030937cf9cc1e3d', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.74', '0.76', '0.66', '0.66', '0.23', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('203', '222', '141403124', '宋婧', '00', NULL, NULL, '1', NULL, '6ea659de279ba1d7a59c2b41914cee00', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.72', '0.78', '0.61', '0.61', '0.51', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('204', '222', '141403125', '王美淇', '00', NULL, NULL, '1', NULL, '5769d58e7811968a9cc2498499214f21', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.68', '0.78', '0.41', '0.41', '0.43', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('205', '222', '141403126', '马静娇', '00', NULL, NULL, '1', NULL, 'e727e6314b5fd4a294bae413d5d7d4d8', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.83', '0.81', '0.58', '0.58', '0.4', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('206', '222', '141403127', '万梓辛', '00', NULL, NULL, '1', NULL, '36a461c6b9b3d2b36baaaf7861209e68', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.84', '0.18', '0.18', '0.14', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('207', '222', '141403128', '聂君鬲', '00', NULL, NULL, '1', NULL, '83f160d9731d258cae4df0b0557989d0', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.88', '0.87', '0.61', '0.61', '0.26', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('208', '222', '141403129', '杨真真', '00', NULL, NULL, '1', NULL, 'f6de3fb9ff4e7fe2272a10b4ea4429ca', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.91', '0.87', '0.57', '0.57', '0.56', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('209', '222', '141403130', '吴菁', '00', NULL, NULL, '1', NULL, 'cb0c38052ffc4ac9839bada270bdeed5', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.69', '0.71', '0.33', '0.33', '0.46', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('210', '222', '141403201', '贾迟', '00', NULL, NULL, '0', NULL, '80d6e1f5ffee362e91e34ddec54f14d6', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.75', '0.8', '0.28', '0.28', '0.52', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('211', '222', '141403202', '周佳永', '00', NULL, NULL, '0', NULL, '2844bb310793c0c2d9560f6e8ddd9980', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.79', '0.67', '0.28', '0.28', '0.14', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('212', '222', '141403203', '张宏声', '00', NULL, NULL, '0', NULL, '42b2b8930773da52bb9f7d453b4fa111', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.74', '0.79', '0.37', '0.37', '0.69', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('213', '222', '141403204', '高帅', '00', NULL, NULL, '0', NULL, '6dafcd960a599ea51a4f89e9daa14871', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.76', '0.69', '0.39', '0.39', '0.54', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('214', '222', '141403205', '岂铭', '00', NULL, NULL, '0', NULL, '8441e5d8c9c781c55d35e177ba269acf', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.69', '0.71', '0.57', '0.57', '0.67', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('215', '222', '141403206', '都书一', '00', NULL, NULL, '0', NULL, '6e20f4ff7a1d5bd17db9c7949f567a25', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.67', '0.77', '0.62', '0.62', '0.3', '1', NULL, NULL);
INSERT INTO "SYS_USER" VALUES ('216', '222', '141403207', '闫拓宇', '00', NULL, NULL, '0', NULL, '73ba7714dbbdac24850e131654659ca4', NULL, '0', '0', NULL, NULL, 'admin', TO_DATE('2020-06-16 09:55:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '0.81', '0.74', '0.14', '0.14', '0.26', '1', NULL, NULL);

-- ----------------------------
-- Table structure for SYS_USER_ONLINE
-- ----------------------------

CREATE TABLE "SYS_USER_ONLINE" (
  "SESSIONID" VARCHAR2(50 BYTE) VISIBLE DEFAULT '' NOT NULL,
  "LOGIN_NAME" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "DEPT_NAME" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "IPADDR" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "LOGIN_LOCATION" VARCHAR2(255 BYTE) VISIBLE DEFAULT '',
  "BROWSER" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "OS" VARCHAR2(50 BYTE) VISIBLE DEFAULT '',
  "STATUS" VARCHAR2(10 BYTE) VISIBLE DEFAULT '',
  "START_TIMESTAMP" DATE VISIBLE,
  "LAST_ACCESS_TIME" DATE VISIBLE,
  "EXPIRE_TIME" NUMBER(10,0) VISIBLE DEFAULT 0


)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_USER_ONLINE"."SESSIONID" IS '用户会话id';
COMMENT ON COLUMN "SYS_USER_ONLINE"."LOGIN_NAME" IS '登录账号';
COMMENT ON COLUMN "SYS_USER_ONLINE"."DEPT_NAME" IS '部门名称';
COMMENT ON COLUMN "SYS_USER_ONLINE"."IPADDR" IS '登录IP地址';
COMMENT ON COLUMN "SYS_USER_ONLINE"."LOGIN_LOCATION" IS '登录地点';
COMMENT ON COLUMN "SYS_USER_ONLINE"."BROWSER" IS '浏览器类型';
COMMENT ON COLUMN "SYS_USER_ONLINE"."OS" IS '操作系统';
COMMENT ON COLUMN "SYS_USER_ONLINE"."STATUS" IS '在线状态on_line在线off_line离线';
COMMENT ON COLUMN "SYS_USER_ONLINE"."START_TIMESTAMP" IS 'session创建时间';
COMMENT ON COLUMN "SYS_USER_ONLINE"."LAST_ACCESS_TIME" IS 'session最后访问时间';
COMMENT ON COLUMN "SYS_USER_ONLINE"."EXPIRE_TIME" IS '超时时间，单位为分钟';
COMMENT ON TABLE "SYS_USER_ONLINE" IS '在线用户记录';

-- ----------------------------
-- Records of SYS_USER_ONLINE
-- ----------------------------

-- ----------------------------
-- Table structure for SYS_USER_POST
-- ----------------------------

CREATE TABLE "SYS_USER_POST" (
  "USER_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "POST_ID" NUMBER(20,0) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_USER_POST"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "SYS_USER_POST"."POST_ID" IS '岗位ID';
COMMENT ON TABLE "SYS_USER_POST" IS '用户与岗位关联表';

-- ----------------------------
-- Records of SYS_USER_POST
-- ----------------------------
INSERT INTO "SYS_USER_POST" VALUES ('1', '1');
INSERT INTO "SYS_USER_POST" VALUES ('100', '1');
INSERT INTO "SYS_USER_POST" VALUES ('101', '3');
INSERT INTO "SYS_USER_POST" VALUES ('102', '3');
INSERT INTO "SYS_USER_POST" VALUES ('103', '3');
INSERT INTO "SYS_USER_POST" VALUES ('1', '3');

-- ----------------------------
-- Table structure for SYS_USER_ROLE
-- ----------------------------

CREATE TABLE "SYS_USER_ROLE" (
  "USER_ID" NUMBER(20,0) VISIBLE NOT NULL,
  "ROLE_ID" NUMBER(20,0) VISIBLE NOT NULL
)

LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "SYS_USER_ROLE"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "SYS_USER_ROLE"."ROLE_ID" IS '角色ID';
COMMENT ON TABLE "SYS_USER_ROLE" IS '用户和角色关联表';

-- ----------------------------
-- Records of SYS_USER_ROLE
-- ----------------------------
INSERT INTO "SYS_USER_ROLE" VALUES ('21', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('183', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('182', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('184', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('185', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('186', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('187', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('188', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('189', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('190', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('200', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('201', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('202', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('203', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('204', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('205', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('206', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('207', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('208', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('210', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('211', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('212', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('213', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('214', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('215', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('216', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('217', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('209', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('227', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('228', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('229', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('230', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('231', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('232', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('233', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('234', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('235', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('246', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('247', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('248', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('249', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('250', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('251', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('252', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('253', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('254', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('1', '2');
INSERT INTO "SYS_USER_ROLE" VALUES ('191', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('192', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('193', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('194', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('195', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('196', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('197', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('198', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('199', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('2', '2');
INSERT INTO "SYS_USER_ROLE" VALUES ('218', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('219', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('100', '2');
INSERT INTO "SYS_USER_ROLE" VALUES ('101', '2');
INSERT INTO "SYS_USER_ROLE" VALUES ('102', '2');
INSERT INTO "SYS_USER_ROLE" VALUES ('103', '2');
INSERT INTO "SYS_USER_ROLE" VALUES ('134', '2');
INSERT INTO "SYS_USER_ROLE" VALUES ('220', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('221', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('222', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('223', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('224', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('225', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('226', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('236', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('237', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('238', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('239', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('240', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('241', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('242', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('243', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('244', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('255', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('256', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('257', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('258', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('259', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('260', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('261', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('262', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('263', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('264', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('265', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('266', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('267', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('268', '3');
INSERT INTO "SYS_USER_ROLE" VALUES ('269', '3');

-- ----------------------------
-- Primary Key structure for table CBT_COMP_INFO
-- ----------------------------
ALTER TABLE "CBT_COMP_INFO" ADD CONSTRAINT "CBT_COMP_INFO_PK" PRIMARY KEY ("COMP_ID");

-- ----------------------------
-- Checks structure for table CBT_COMP_INFO
-- ----------------------------
ALTER TABLE "CBT_COMP_INFO" ADD CONSTRAINT "CBT_COMP_INFO_CHK1" CHECK (PF<=1 and cl<=1 and ta<=1 and pa<=1 and ce<=1 and re<=1 and PF>=0 and cl>=0 and ta>=0 and pa>=0 and ce>=0 and re>=0 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CBT_COMP_INFO" ADD CONSTRAINT "CBT_COMP_INFO_CHK2" CHECK (start_time<end_time) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CBT_COMP_INFO" ADD CONSTRAINT "SYS_C0010249" CHECK ("COMP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CBT_COMP_INFO" ADD CONSTRAINT "SYS_C0010250" CHECK ("COMP_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table CBT_COMP_TEAM
-- ----------------------------
ALTER TABLE "CBT_COMP_TEAM" ADD CONSTRAINT "SYS_C0010251" CHECK ("TEAM_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CBT_COMP_TEAM" ADD CONSTRAINT "SYS_C0010252" CHECK ("COMP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CBT_COMP_TEAM" ADD CONSTRAINT "SYS_C0010253" CHECK ("STATUS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table CBT_TEAM_USER
-- ----------------------------
ALTER TABLE "CBT_TEAM_USER" ADD CONSTRAINT "SYS_C0010254" CHECK ("TEAM_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CBT_TEAM_USER" ADD CONSTRAINT "SYS_C0010255" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CBT_TEAM_USER" ADD CONSTRAINT "SYS_C0010256" CHECK ("TU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "SYS_C0010259" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "SYS_C0010260" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "SYS_C0010261" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_CALENDARS
-- ----------------------------
ALTER TABLE "QRTZ_CALENDARS" ADD CONSTRAINT "SYS_C0010262" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_CALENDARS" ADD CONSTRAINT "SYS_C0010263" CHECK ("CALENDAR_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_CALENDARS" ADD CONSTRAINT "SYS_C0010264" CHECK ("CALENDAR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0010265" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0010266" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0010267" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0010268" CHECK ("CRON_EXPRESSION" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010269" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010270" CHECK ("ENTRY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010271" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010272" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010273" CHECK ("INSTANCE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010274" CHECK ("FIRED_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010275" CHECK ("SCHED_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010276" CHECK ("PRIORITY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0010277" CHECK ("STATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_JOB_DETAILS
-- ----------------------------
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010278" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010279" CHECK ("JOB_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010280" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010281" CHECK ("JOB_CLASS_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010282" CHECK ("IS_DURABLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010283" CHECK ("IS_NONCONCURRENT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010284" CHECK ("IS_UPDATE_DATA" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0010285" CHECK ("REQUESTS_RECOVERY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_LOCKS
-- ----------------------------
ALTER TABLE "QRTZ_LOCKS" ADD CONSTRAINT "SYS_C0010286" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_LOCKS" ADD CONSTRAINT "SYS_C0010287" CHECK ("LOCK_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
ALTER TABLE "QRTZ_PAUSED_TRIGGER_GRPS" ADD CONSTRAINT "SYS_C0010288" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_PAUSED_TRIGGER_GRPS" ADD CONSTRAINT "SYS_C0010289" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_SCHEDULER_STATE
-- ----------------------------
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0010290" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0010291" CHECK ("INSTANCE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0010292" CHECK ("LAST_CHECKIN_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0010293" CHECK ("CHECKIN_INTERVAL" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0010294" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0010295" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0010296" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0010297" CHECK ("REPEAT_COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0010298" CHECK ("REPEAT_INTERVAL" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0010299" CHECK ("TIMES_TRIGGERED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "SYS_C0010300" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "SYS_C0010301" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "SYS_C0010302" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table QRTZ_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010303" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010304" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010305" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010306" CHECK ("JOB_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010307" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010308" CHECK ("TRIGGER_STATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010309" CHECK ("TRIGGER_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0010310" CHECK ("START_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_CONFIG
-- ----------------------------
ALTER TABLE "SYS_CONFIG" ADD CONSTRAINT "SYS_C0010311" CHECK ("CONFIG_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_DEPT
-- ----------------------------
ALTER TABLE "SYS_DEPT" ADD CONSTRAINT "SYS_C0010312" CHECK ("DEPT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_DICT_DATA
-- ----------------------------
ALTER TABLE "SYS_DICT_DATA" ADD CONSTRAINT "SYS_C0010313" CHECK ("DICT_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_DICT_TYPE
-- ----------------------------
ALTER TABLE "SYS_DICT_TYPE" ADD CONSTRAINT "SYS_C0010314" CHECK ("DICT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_JOB
-- ----------------------------
ALTER TABLE "SYS_JOB" ADD CONSTRAINT "SYS_C0010315" CHECK ("JOB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_JOB" ADD CONSTRAINT "SYS_C0010316" CHECK ("JOB_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_JOB" ADD CONSTRAINT "SYS_C0010317" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_JOB" ADD CONSTRAINT "SYS_C0010318" CHECK ("INVOKE_TARGET" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_JOB_LOG
-- ----------------------------
ALTER TABLE "SYS_JOB_LOG" ADD CONSTRAINT "SYS_C0010319" CHECK ("JOB_LOG_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_JOB_LOG" ADD CONSTRAINT "SYS_C0010320" CHECK ("JOB_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_JOB_LOG" ADD CONSTRAINT "SYS_C0010321" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_JOB_LOG" ADD CONSTRAINT "SYS_C0010322" CHECK ("INVOKE_TARGET" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_LOGININFOR
-- ----------------------------
ALTER TABLE "SYS_LOGININFOR" ADD CONSTRAINT "SYS_C0010323" CHECK ("INFO_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_MENU
-- ----------------------------
ALTER TABLE "SYS_MENU" ADD CONSTRAINT "SYS_C0010324" CHECK ("MENU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_MENU" ADD CONSTRAINT "SYS_C0010325" CHECK ("MENU_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_NOTICE
-- ----------------------------
ALTER TABLE "SYS_NOTICE" ADD CONSTRAINT "SYS_C0010326" CHECK ("NOTICE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_NOTICE" ADD CONSTRAINT "SYS_C0010327" CHECK ("NOTICE_TITLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_NOTICE" ADD CONSTRAINT "SYS_C0010328" CHECK ("NOTICE_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_OPER_LOG
-- ----------------------------
ALTER TABLE "SYS_OPER_LOG" ADD CONSTRAINT "SYS_C0010329" CHECK ("OPER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_POST
-- ----------------------------
ALTER TABLE "SYS_POST" ADD CONSTRAINT "SYS_C0010330" CHECK ("POST_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_POST" ADD CONSTRAINT "SYS_C0010331" CHECK ("POST_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_POST" ADD CONSTRAINT "SYS_C0010332" CHECK ("POST_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_POST" ADD CONSTRAINT "SYS_C0010333" CHECK ("POST_SORT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_POST" ADD CONSTRAINT "SYS_C0010334" CHECK ("STATUS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_ROLE
-- ----------------------------
ALTER TABLE "SYS_ROLE" ADD CONSTRAINT "SYS_C0010335" CHECK ("ROLE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_ROLE" ADD CONSTRAINT "SYS_C0010336" CHECK ("ROLE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_ROLE" ADD CONSTRAINT "SYS_C0010337" CHECK ("ROLE_KEY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_ROLE" ADD CONSTRAINT "SYS_C0010338" CHECK ("ROLE_SORT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_ROLE" ADD CONSTRAINT "SYS_C0010339" CHECK ("STATUS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_ROLE_DEPT
-- ----------------------------
ALTER TABLE "SYS_ROLE_DEPT" ADD CONSTRAINT "SYS_C0010340" CHECK ("ROLE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_ROLE_DEPT" ADD CONSTRAINT "SYS_C0010341" CHECK ("DEPT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_ROLE_MENU
-- ----------------------------
ALTER TABLE "SYS_ROLE_MENU" ADD CONSTRAINT "SYS_C0010342" CHECK ("ROLE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_ROLE_MENU" ADD CONSTRAINT "SYS_C0010343" CHECK ("MENU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_USER
-- ----------------------------
ALTER TABLE "SYS_USER" ADD CONSTRAINT "SYS_C0010344" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_USER" ADD CONSTRAINT "SYS_C0010345" CHECK ("LOGIN_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_USER_ONLINE
-- ----------------------------
ALTER TABLE "SYS_USER_ONLINE" ADD CONSTRAINT "SYS_C0010346" CHECK ("SESSIONID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_USER_POST
-- ----------------------------
ALTER TABLE "SYS_USER_POST" ADD CONSTRAINT "SYS_C0010347" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_USER_POST" ADD CONSTRAINT "SYS_C0010348" CHECK ("POST_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table SYS_USER_ROLE
-- ----------------------------
ALTER TABLE "SYS_USER_ROLE" ADD CONSTRAINT "SYS_C0010349" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "SYS_USER_ROLE" ADD CONSTRAINT "SYS_C0010350" CHECK ("ROLE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

create sequence seq_sys_dept
    increment by 1
    start with 300
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_user
    increment by 1
    start with 300
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_post
    increment by 1
    start with 10
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_role
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_menu
    increment by 1
    start with 2200
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_oper_log
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_dict_type
    increment by 1
    start with 200
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_dict_data
    increment by 1
    start with 200
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_config
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_logininfor
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_job
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_job_log
    increment by 1
    start with 1
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_sys_notice
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_cbt_comp_info
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_cbt_comp_team
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

create sequence seq_cbt_team_user
    increment by 1
    start with 100
    nomaxvalue
    nominvalue
    cache 20;

CREATE OR REPLACE function find_in_set(arg1 in varchar2, arg2 in varchar)
    return number is
    Result number;
begin
    select instr(',' || arg2 || ',', ',' || arg1 || ',') into Result from dual;
    return (Result);
end find_in_set;

